Export Format
Before you can use the ADP Interface, you must specify the format of the exported payroll file: either the standard ADP format or the ADPRATE format.
When you execute the export process, Time and Expense with ESS exports payroll data to worktables. Then it reads the ExportTimesheets.properties file on the server to determine the final format of the export.
One of the parameters in the ExportTimesheets.properties file is PAYROLL=. You must supply one of the following values:
- PAYROLL=NONE — The exported payroll file is not transformed.
- PAYROLL=ADP — The exported payroll file is transformed using the standard ADP format.
- PAYROLL=ADPRATE — The exported payroll file is transformed using the ADPRATE format. This format contains all the columns of the standard layout and also includes a temporary rate that overrides ADP's rate for the employee.
ADP Format
When you use the ADP format, the values in the ADP fields come from the following sources.
| ADP Field | Source |
|---|---|
| Co Code | Payroll ID on the Employee Information screen. |
| Batch ID | Batch ID on the Export screen. |
| File # | Payroll Employee ID on the Employee Information screen. |
| Reg Hours | Sum of the hours charged to the pay type that has a Payroll Map Code of Regular. |
| Reg Earnings | Not implemented. |
| OT Hours | Sum of the hours charged to the pay type that has a Payroll Map Code of Overtime. |
| OT Earnings | Not implemented. |
| Earnings 3 Code | Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 3. |
| Earnings 3 Amount | Not implemented. |
| Earnings 4 Code | Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 4. |
| Earnings 4 Amount | Not implemented. |
| Earnings 5 Code | Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 5. |
| Earnings 5 Amount | Not implemented. |
| Hours 3 Code | Payroll Earnings Code from the pay type that has a Payroll Map Code of Hours 3. |
| Hours 3 Amount | Sum of the hours charged to the pay type that has a Payroll Map Code of Hours 3. |
| Hours 4 Code | Payroll Earnings Code from the pay type that has a Payroll Map Code of Hours 4. |
| Hours 4 Amount | Sum of the hours charged to the pay type that has a Payroll Map Code of Hours 4. |
ADPRATE Format
When you use the ADPRATE format, the values in the ADP fields come from the following sources.
| ADP Field | Source |
|---|---|
| Co Code | Payroll ID on the Employee Information screen. |
| Batch ID | Batch ID on the Export screen. |
| File # | Payroll Employee ID on the Employee Information screen. |
| Reg Hours | Sum of the hours charged to the pay type that has a Payroll Map Code of Regular. |
| Reg Earnings | Not implemented. |
| OT Hours | Sum of the hours charged to the pay type that has a Payroll Map Code of Overtime. |
| OT Earnings | Not implemented. |
| Earnings 3 Code | Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 3. |
| Earnings 3 Amount | Not implemented. |
| Earnings 4 Code | Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 4. |
| Earnings 4 Amount | Not implemented. |
| Earnings 5 Code | Payroll Earnings Code from the pay type that has a Payroll Map Code of Earnings 5. |
| Earnings 5 Amount | Not implemented. |
| Hours 3 Code | Payroll Earnings Code from the pay type that has a Payroll Map Code of Hours 3. |
| Hours 3 Amount | Sum of the hours charged to the pay type that has a Payroll Map Code of Hours 3. |
| Hours 4 Code | Payroll Earnings Code from the pay type that has a Payroll Map Code of Hours 4. |
| Hours 4 Amount | Sum of the hours charged to the pay type that has a Payroll Map Code of Hours 4. |
| Temp Rate | Sum of the Amount divided by the sum of Hours. Based on User-Defined Rate 1. |